import pandas as pd

import 去除企宽

if __name__ == '__main__':
    from 小区健康度 import Batch

    ont = pd.read_csv("D:\\temp\\账号上联信息.csv",
                      usecols=['account', '一级分光器', '二级分光器', '一级分纤箱', '二级分纤箱'],
                      dtype={'account': str})
    data = pd.read_csv(去除企宽.getPath(Batch.batch), dtype={'account': str})
    data['account'] = data['account'].str[1:]
    data = data.merge(ont, on='account', how='left')
    data.to_csv("D:\\temp\\7月中断带分光器.csv", index=False)
